SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_cron_trigger
-- ----------------------------
DROP TABLE IF EXISTS `t_cron_trigger`;
CREATE TABLE `t_cron_trigger`
(
    `id`          int(8) NOT NULL AUTO_INCREMENT COMMENT '任务id',
    `cron`        varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'cron表达式',
    `create_time` datetime                     DEFAULT NULL COMMENT '创建时间',
    `update_time` datetime                     DEFAULT NULL COMMENT '更新时间',
    `is_deleted`  int(1)                       DEFAULT '0' COMMENT '作废状态 0-否 1-是',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 3
  DEFAULT CHARSET = utf8
  COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_cron_trigger
-- ----------------------------
BEGIN;
INSERT INTO `t_cron_trigger`
VALUES (1, '0/10 * * * * ?', '2019-10-30 13:40:14', NULL, 0);
INSERT INTO `t_cron_trigger`
VALUES (2, '0/7 * * * * ?', '2019-10-30 13:40:34', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;